﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet_ohl" targetNamespace="http://tempuri.org/DataSet_ohl.xsd" xmlns:mstns="http://tempuri.org/DataSet_ohl.xsd" xmlns="http://tempuri.org/DataSet_ohl.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="GanaderiaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GanaderiaConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.GanaderiaConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="animalTableAdapter" GeneratorDataComponentClassName="animalTableAdapter" Name="animal" UserDataComponentName="animalTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.animal" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillAnimal" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetAnimal" GeneratorSourceName="FillAnimal" GetMethodModifier="Public" GetMethodName="GetAnimal" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetAnimal" UserSourceName="FillAnimal">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [animal] WHERE (([AnimalId] = @Original_AnimalId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AnimalId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnimalId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [animal] ([sexo], [numero], [letra], [ano], [nombre], [fechanac], [hierro], [propiedad], [encaste], [familia], [arete], [no_padre], [ltra_padre], [ano_padre], [hie_padre], [id_padre], [no_madre], [ltra_madre], [ano_madre], [hie_madre], [id_madre], [abuelo_mat], [ubicacion], [estatus], [muerto], [fechabaja], [lidia_acCal], [lidia_apCal], [lidia_ac], [lidia_ap], [tienta_acCal], [tienta_apCal], [tienta_ac], [tienta_ap], [porcien_cs], [fenotipo], [comportamiento], [marca1], [marca2], [marca3], [pelaje1], [pelaje2], [pelaje3], [cometario], [creado], [modificado], [edadvivo], [edadmuerto]) VALUES (@sexo, @numero, @letra, @ano, @nombre, @fechanac, @hierro, @propiedad, @encaste, @familia, @arete, @no_padre, @ltra_padre, @ano_padre, @hie_padre, @id_padre, @no_madre, @ltra_madre, @ano_madre, @hie_madre, @id_madre, @abuelo_mat, @ubicacion, @estatus, @muerto, @fechabaja, @lidia_acCal, @lidia_apCal, @lidia_ac, @lidia_ap, @tienta_acCal, @tienta_apCal, @tienta_ac, @tienta_ap, @porcien_cs, @fenotipo, @comportamiento, @marca1, @marca2, @marca3, @pelaje1, @pelaje2, @pelaje3, @cometario, @creado, @modificado, @edadvivo, @edadmuerto)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@sexo" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="sexo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@numero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@letra" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="letra" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@fechanac" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechanac" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hierro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hierro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@propiedad" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="propiedad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@encaste" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="encaste" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@familia" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="familia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@arete" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="arete" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@no_padre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="no_padre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ltra_padre" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ltra_padre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ano_padre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ano_padre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hie_padre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hie_padre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_padre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_padre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@no_madre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="no_madre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ltra_madre" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ltra_madre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ano_madre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ano_madre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hie_madre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hie_madre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_madre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_madre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@abuelo_mat" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="abuelo_mat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ubicacion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ubicacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@estatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="estatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@muerto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="muerto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@fechabaja" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="fechabaja" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@lidia_acCal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lidia_acCal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@lidia_apCal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lidia_apCal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@lidia_ac" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lidia_ac" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@lidia_ap" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lidia_ap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@tienta_acCal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="tienta_acCal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@tienta_apCal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="tienta_apCal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@tienta_ac" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="tienta_ac" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@tienta_ap" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="tienta_ap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@porcien_cs" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="porcien_cs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@fenotipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fenotipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@comportamiento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="comportamiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@marca1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="marca1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@marca2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="marca2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@marca3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="marca3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@pelaje1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pelaje1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@pelaje2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pelaje2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@pelaje3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pelaje3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cometario" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="cometario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@creado" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="creado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@modificado" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="modificado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@edadvivo" Precision="17" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="edadvivo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@edadmuerto" Precision="17" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="edadmuerto" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        AnimalId, sexo, numero, letra, ano, CONVERT (VARCHAR(4), ISNULL(numero, 0), 0) + ISNULL(letra, ' ') + CONVERT (VARCHAR(4), ISNULL(ano, 0), 0) AS cveAnimal,  nombre, fechanac, hierro, propiedad, encaste, familia, arete, no_padre, ltra_padre, ano_padre, hie_padre, id_padre, no_madre, 
                         ltra_madre, ano_madre, hie_madre, id_madre, abuelo_mat, ubicacion, estatus, muerto, fechabaja, lidia_acCal, lidia_apCal, lidia_ac, lidia_ap, tienta_acCal, 
                         tienta_apCal, tienta_ac, tienta_ap, porcien_cs, fenotipo, comportamiento, marca1, marca2, marca3, pelaje1, pelaje2, pelaje3, 
                         cometario, creado, modificado, edadvivo, edadmuerto
FROM            animal</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       animal
SET                sexo = @sexo, numero = @numero, letra = @letra, ano = @ano, nombre = @nombre, fechanac = @fechanac, hierro = @hierro, propiedad = @propiedad, 
                         encaste = @encaste, familia = @familia, arete = @arete, no_padre = @no_padre, ltra_padre = @ltra_padre, ano_padre = @ano_padre, hie_padre = @hie_padre, 
                         id_padre = @id_padre, no_madre = @no_madre, ltra_madre = @ltra_madre, ano_madre = @ano_madre, hie_madre = @hie_madre, id_madre = @id_madre, 
                         abuelo_mat = @abuelo_mat, ubicacion = @ubicacion, estatus = @estatus, muerto = @muerto, fechabaja = @fechabaja, lidia_acCal = @lidia_acCal, 
                         lidia_apCal = @lidia_apCal, lidia_ac = @lidia_ac, lidia_ap = @lidia_ap, tienta_acCal = @tienta_acCal, tienta_apCal = @tienta_apCal, tienta_ac = @tienta_ac, 
                         tienta_ap = @tienta_ap, porcien_cs = @porcien_cs, fenotipo = @fenotipo, comportamiento = @comportamiento, marca1 = @marca1, marca2 = @marca2, 
                         marca3 = @marca3, pelaje1 = @pelaje1, pelaje2 = @pelaje2, pelaje3 = @pelaje3, cometario = @cometario, creado = @creado, modificado = @modificado
WHERE        (AnimalId = @Original_AnimalId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="sexo" ColumnName="sexo" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="char(1)" DbType="AnsiString" Direction="Input" ParameterName="@sexo" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="sexo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="numero" ColumnName="numero" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@numero" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="letra" ColumnName="letra" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(2)" DbType="AnsiString" Direction="Input" ParameterName="@letra" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumn="letra" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ano" ColumnName="ano" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="nombre" ColumnName="nombre" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="fechanac" ColumnName="fechanac" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fechanac" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="fechanac" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="hierro" ColumnName="hierro" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@hierro" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="hierro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="propiedad" ColumnName="propiedad" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@propiedad" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="propiedad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="encaste" ColumnName="encaste" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@encaste" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="encaste" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="familia" ColumnName="familia" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(1)" DbType="AnsiString" Direction="Input" ParameterName="@familia" Precision="0" ProviderType="VarChar" Scale="0" Size="1" SourceColumn="familia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="arete" ColumnName="arete" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@arete" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="arete" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="no_padre" ColumnName="no_padre" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@no_padre" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="no_padre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ltra_padre" ColumnName="ltra_padre" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="char(2)" DbType="AnsiString" Direction="Input" ParameterName="@ltra_padre" Precision="0" ProviderType="Char" Scale="0" Size="2" SourceColumn="ltra_padre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ano_padre" ColumnName="ano_padre" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ano_padre" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ano_padre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="hie_padre" ColumnName="hie_padre" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@hie_padre" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="hie_padre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="id_padre" ColumnName="id_padre" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id_padre" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id_padre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="no_madre" ColumnName="no_madre" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@no_madre" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="no_madre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ltra_madre" ColumnName="ltra_madre" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="char(2)" DbType="AnsiString" Direction="Input" ParameterName="@ltra_madre" Precision="0" ProviderType="Char" Scale="0" Size="2" SourceColumn="ltra_madre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ano_madre" ColumnName="ano_madre" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ano_madre" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ano_madre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="hie_madre" ColumnName="hie_madre" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@hie_madre" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="hie_madre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="id_madre" ColumnName="id_madre" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id_madre" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id_madre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="abuelo_mat" ColumnName="abuelo_mat" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="char(10)" DbType="AnsiString" Direction="Input" ParameterName="@abuelo_mat" Precision="0" ProviderType="Char" Scale="0" Size="10" SourceColumn="abuelo_mat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ubicacion" ColumnName="ubicacion" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@ubicacion" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="ubicacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="estatus" ColumnName="estatus" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@estatus" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="estatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="muerto" ColumnName="muerto" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@muerto" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="muerto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="fechabaja" ColumnName="fechabaja" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fechabaja" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="fechabaja" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="lidia_acCal" ColumnName="lidia_acCal" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@lidia_acCal" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="lidia_acCal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="lidia_apCal" ColumnName="lidia_apCal" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@lidia_apCal" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="lidia_apCal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="lidia_ac" ColumnName="lidia_ac" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@lidia_ac" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="lidia_ac" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="lidia_ap" ColumnName="lidia_ap" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@lidia_ap" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="lidia_ap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="tienta_acCal" ColumnName="tienta_acCal" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@tienta_acCal" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="tienta_acCal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="tienta_apCal" ColumnName="tienta_apCal" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@tienta_apCal" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="tienta_apCal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="tienta_ac" ColumnName="tienta_ac" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@tienta_ac" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="tienta_ac" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="tienta_ap" ColumnName="tienta_ap" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@tienta_ap" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="tienta_ap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="porcien_cs" ColumnName="porcien_cs" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@porcien_cs" Precision="0" ProviderType="Float" Scale="0" Size="8" SourceColumn="porcien_cs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="fenotipo" ColumnName="fenotipo" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@fenotipo" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="fenotipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="comportamiento" ColumnName="comportamiento" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@comportamiento" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="comportamiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="marca1" ColumnName="marca1" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(2)" DbType="AnsiString" Direction="Input" ParameterName="@marca1" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumn="marca1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="marca2" ColumnName="marca2" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(2)" DbType="AnsiString" Direction="Input" ParameterName="@marca2" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumn="marca2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="marca3" ColumnName="marca3" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(2)" DbType="AnsiString" Direction="Input" ParameterName="@marca3" Precision="0" ProviderType="VarChar" Scale="0" Size="2" SourceColumn="marca3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="pelaje1" ColumnName="pelaje1" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@pelaje1" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="pelaje1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="pelaje2" ColumnName="pelaje2" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@pelaje2" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="pelaje2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="pelaje3" ColumnName="pelaje3" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@pelaje3" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="pelaje3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="cometario" ColumnName="cometario" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@cometario" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="cometario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="creado" ColumnName="creado" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@creado" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="creado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="modificado" ColumnName="modificado" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@modificado" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="modificado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_AnimalId" ColumnName="AnimalId" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_AnimalId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AnimalId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AnimalId" DataSetColumn="AnimalId" />
              <Mapping SourceColumn="sexo" DataSetColumn="sexo" />
              <Mapping SourceColumn="numero" DataSetColumn="numero" />
              <Mapping SourceColumn="letra" DataSetColumn="letra" />
              <Mapping SourceColumn="ano" DataSetColumn="ano" />
              <Mapping SourceColumn="nombre" DataSetColumn="nombre" />
              <Mapping SourceColumn="fechanac" DataSetColumn="fechanac" />
              <Mapping SourceColumn="hierro" DataSetColumn="hierro" />
              <Mapping SourceColumn="propiedad" DataSetColumn="propiedad" />
              <Mapping SourceColumn="encaste" DataSetColumn="encaste" />
              <Mapping SourceColumn="familia" DataSetColumn="familia" />
              <Mapping SourceColumn="arete" DataSetColumn="arete" />
              <Mapping SourceColumn="no_padre" DataSetColumn="no_padre" />
              <Mapping SourceColumn="ltra_padre" DataSetColumn="ltra_padre" />
              <Mapping SourceColumn="ano_padre" DataSetColumn="ano_padre" />
              <Mapping SourceColumn="hie_padre" DataSetColumn="hie_padre" />
              <Mapping SourceColumn="id_padre" DataSetColumn="id_padre" />
              <Mapping SourceColumn="no_madre" DataSetColumn="no_madre" />
              <Mapping SourceColumn="ltra_madre" DataSetColumn="ltra_madre" />
              <Mapping SourceColumn="ano_madre" DataSetColumn="ano_madre" />
              <Mapping SourceColumn="hie_madre" DataSetColumn="hie_madre" />
              <Mapping SourceColumn="id_madre" DataSetColumn="id_madre" />
              <Mapping SourceColumn="abuelo_mat" DataSetColumn="abuelo_mat" />
              <Mapping SourceColumn="ubicacion" DataSetColumn="ubicacion" />
              <Mapping SourceColumn="estatus" DataSetColumn="estatus" />
              <Mapping SourceColumn="muerto" DataSetColumn="muerto" />
              <Mapping SourceColumn="fechabaja" DataSetColumn="fechabaja" />
              <Mapping SourceColumn="lidia_acCal" DataSetColumn="lidia_acCal" />
              <Mapping SourceColumn="lidia_apCal" DataSetColumn="lidia_apCal" />
              <Mapping SourceColumn="lidia_ac" DataSetColumn="lidia_ac" />
              <Mapping SourceColumn="lidia_ap" DataSetColumn="lidia_ap" />
              <Mapping SourceColumn="tienta_acCal" DataSetColumn="tienta_acCal" />
              <Mapping SourceColumn="tienta_apCal" DataSetColumn="tienta_apCal" />
              <Mapping SourceColumn="tienta_ac" DataSetColumn="tienta_ac" />
              <Mapping SourceColumn="tienta_ap" DataSetColumn="tienta_ap" />
              <Mapping SourceColumn="porcien_cs" DataSetColumn="porcien_cs" />
              <Mapping SourceColumn="fenotipo" DataSetColumn="fenotipo" />
              <Mapping SourceColumn="comportamiento" DataSetColumn="comportamiento" />
              <Mapping SourceColumn="marca1" DataSetColumn="marca1" />
              <Mapping SourceColumn="marca2" DataSetColumn="marca2" />
              <Mapping SourceColumn="marca3" DataSetColumn="marca3" />
              <Mapping SourceColumn="pelaje1" DataSetColumn="pelaje1" />
              <Mapping SourceColumn="pelaje2" DataSetColumn="pelaje2" />
              <Mapping SourceColumn="pelaje3" DataSetColumn="pelaje3" />
              <Mapping SourceColumn="cometario" DataSetColumn="cometario" />
              <Mapping SourceColumn="creado" DataSetColumn="creado" />
              <Mapping SourceColumn="modificado" DataSetColumn="modificado" />
              <Mapping SourceColumn="edadvivo" DataSetColumn="edadvivo1" />
              <Mapping SourceColumn="edadmuerto" DataSetColumn="edadmuerto1" />
              <Mapping SourceColumn="cveAnimal" DataSetColumn="cveAnimal" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.animal" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillAniEmpByToro1" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetAniEmpByToro1" GeneratorSourceName="FillAniEmpByToro1" GetMethodModifier="Public" GetMethodName="GetAniEmpByToro1" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAniEmpByToro1" UserSourceName="FillAniEmpByToro1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        sexo, CONVERT(VARCHAR(4), ISNULL(numero, 0), 0) + ISNULL(letra, ' ') + CONVERT(VARCHAR(4), ISNULL(ano, 0), 0) AS cveAnimal, nombre, AnimalId, numero, letra, 
                         ano, fechabaja, hierro, propiedad, edadvivo
FROM            animal
WHERE        (AnimalId NOT IN
                             (SELECT        toroId
                               FROM            empadre AS empadre_1
                               WHERE        (ano = @ano) AND (fechafin IS NULL))) AND (sexo = 'T') AND (fechabaja IS NULL) AND (propiedad = 'SFC') AND (estatus = 'MS') AND (edadvivo &gt; @edadvivo) 
ORDER BY   cveAnimal
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="edadvivo" ColumnName="edadvivo" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="numeric(17, 6)" DbType="Decimal" Direction="Input" ParameterName="@edadvivo" Precision="17" ProviderType="Decimal" Scale="6" Size="9" SourceColumn="edadvivo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ano" ColumnName="ano" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.animal" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillAniEmpByToro2" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetAniEmpByToro2" GeneratorSourceName="FillAniEmpByToro2" GetMethodModifier="Public" GetMethodName="GetAniEmpByToro2" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAniEmpByToro2" UserSourceName="FillAniEmpByToro2">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        sexo, CONVERT(VARCHAR(4), ISNULL(numero, 0), 0) + ISNULL(letra, ' ') + CONVERT(VARCHAR(4), ISNULL(ano, 0), 0) AS cveAnimal, nombre, AnimalId, numero, letra, 
                         ano, fechabaja, hierro, propiedad, edadvivo
FROM            animal
WHERE        (AnimalId NOT IN
                             (SELECT        toroId
                               FROM            empadre AS empadre_1
                               WHERE        (ano = @ano) AND (fechafin IS NULL))) AND (sexo = 'T') AND (fechabaja IS NULL) AND (estatus = 'MS') AND (edadvivo &gt; @edadvivo) 
ORDER BY   cveAnimal
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="edadvivo" ColumnName="edadvivo" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="numeric(17, 6)" DbType="Decimal" Direction="Input" ParameterName="@edadvivo" Precision="17" ProviderType="Decimal" Scale="6" Size="9" SourceColumn="edadvivo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ano" ColumnName="ano" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.animal" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillAniEmpByVaca1" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetAniEmpByVaca1" GeneratorSourceName="FillAniEmpByVaca1" GetMethodModifier="Public" GetMethodName="GetAniEmpByVaca1" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAniEmpByVaca1" UserSourceName="FillAniEmpByVaca1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        sexo, CONVERT(VARCHAR(4), ISNULL(numero, 0), 0) + ISNULL(letra, ' ') + CONVERT(VARCHAR(4), ISNULL(ano, 0), 0) AS cveAnimal, nombre, AnimalId, numero, letra, 
                         ano, fechabaja, hierro, propiedad, edadvivo 
FROM            animal 
WHERE        (AnimalId NOT IN 
                             (SELECT        vacaId 
                               FROM            Emp_Movs AS emp_movs_1 
                               WHERE        (ano = @ano) AND (fechafin IS NULL))) AND (sexo = 'V') AND (fechabaja IS NULL) AND (propiedad = 'SFC') AND (estatus = 'HP') AND (edadvivo &gt; @edadvivo)  
ORDER BY   cveAnimal
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="edadvivo" ColumnName="edadvivo" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="numeric(17, 6)" DbType="Decimal" Direction="Input" ParameterName="@edadvivo" Precision="17" ProviderType="Decimal" Scale="6" Size="9" SourceColumn="edadvivo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ano" ColumnName="ano" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.animal" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillAniEmpByVaca2" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetAniEmpByVaca2" GeneratorSourceName="FillAniEmpByVaca2" GetMethodModifier="Public" GetMethodName="GetAniEmpByVaca2" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAniEmpByVaca2" UserSourceName="FillAniEmpByVaca2">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        sexo, CONVERT(VARCHAR(4), ISNULL(numero, 0), 0) + ISNULL(letra, ' ') + CONVERT(VARCHAR(4), ISNULL(ano, 0), 0) AS cveAnimal, nombre, AnimalId, numero, letra, 
                         ano, fechabaja, hierro, propiedad, edadvivo 
FROM            animal 
WHERE        (AnimalId NOT IN 
                             (SELECT        vacaId 
                               FROM            Emp_Movs AS emp_movs_1 
                               WHERE        (ano = @ano) AND (fechafin IS NULL))) AND (sexo = 'V') AND (fechabaja IS NULL) AND (estatus = 'HP') AND (edadvivo &gt; @edadvivo)  
ORDER BY   cveAnimal
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="edadvivo" ColumnName="edadvivo" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="numeric(17, 6)" DbType="Decimal" Direction="Input" ParameterName="@edadvivo" Precision="17" ProviderType="Decimal" Scale="6" Size="9" SourceColumn="edadvivo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ano" ColumnName="ano" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.animal" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillAnimalByClave" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetAnimalByClave" GeneratorSourceName="FillAnimalByClave" GetMethodModifier="Public" GetMethodName="GetAnimalByClave" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAnimalByClave" UserSourceName="FillAnimalByClave">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AnimalId, abuelo_mat, ano, ano_madre, ano_padre, arete, cometario, comportamiento, creado, CONVERT (VARCHAR(4), ISNULL(numero, 0), 0) + ISNULL(letra, ' ') + CONVERT (VARCHAR(4), ISNULL(ano, 0), 0) AS cveAnimal, edadmuerto, edadvivo, encaste, estatus, familia, fechabaja, fechanac, fenotipo, hie_madre, hie_padre, hierro, id_madre, id_padre, letra, lidia_ac, lidia_acCal, lidia_ap, lidia_apCal, ltra_madre, ltra_padre, marca1, marca2, marca3, modificado, muerto, no_madre, no_padre, nombre, numero, pelaje1, pelaje2, pelaje3, porcien_cs, propiedad, sexo, tienta_ac, tienta_acCal, tienta_ap, tienta_apCal, ubicacion FROM animal WHERE (CONVERT (VARCHAR(4), ISNULL(numero, 0), 0) + ISNULL(letra, ' ') + CONVERT (VARCHAR(4), ISNULL(ano, 0), 0) LIKE @cadena) ORDER BY numero, letra, ano, sexo</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="cadena" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@cadena" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.animal" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillAnimalByMadre" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetAnimalByMadre" GeneratorSourceName="FillAnimalByMadre" GetMethodModifier="Public" GetMethodName="GetAnimalByMadre" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAnimalByMadre" UserSourceName="FillAnimalByMadre">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AnimalId, abuelo_mat, ano, ano_madre, ano_padre, arete, cometario, comportamiento, creado, CONVERT (VARCHAR(4), ISNULL(numero, 0), 0) + ISNULL(letra, ' ') + CONVERT (VARCHAR(4), ISNULL(ano, 0), 0) AS cveAnimal, edadmuerto, edadvivo, encaste, estatus, familia, fechabaja, fechanac, fenotipo, hie_madre, hie_padre, hierro, id_madre, id_padre, letra, lidia_ac, lidia_acCal, lidia_ap, lidia_apCal, ltra_madre, ltra_padre, marca1, marca2, marca3, modificado, muerto, no_madre, no_padre, nombre, numero, pelaje1, pelaje2, pelaje3, porcien_cs, propiedad, sexo, tienta_ac, tienta_acCal, tienta_ap, tienta_apCal, ubicacion FROM animal WHERE (CONVERT (VARCHAR(4), ISNULL(no_madre, 0), 0) + ISNULL(ltra_madre, ' ') + CONVERT (VARCHAR(4), ISNULL(ano_madre, 0), 0) LIKE @madre) ORDER BY numero, letra, ano, sexo</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="madre" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@madre" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.animal" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillAnimalByPadre" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetAnimalByPadre" GeneratorSourceName="FillAnimalByPadre" GetMethodModifier="Public" GetMethodName="GetAnimalByPadre" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAnimalByPadre" UserSourceName="FillAnimalByPadre">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AnimalId, abuelo_mat, ano, ano_madre, ano_padre, arete, cometario, comportamiento, creado, CONVERT (VARCHAR(4), ISNULL(numero, 0), 0) + ISNULL(letra, ' ') + CONVERT (VARCHAR(4), ISNULL(ano, 0), 0) AS cveAnimal, edadmuerto, edadvivo, encaste, estatus, familia, fechabaja, fechanac, fenotipo, hie_madre, hie_padre, hierro, id_madre, id_padre, letra, lidia_ac, lidia_acCal, lidia_ap, lidia_apCal, ltra_madre, ltra_padre, marca1, marca2, marca3, modificado, muerto, no_madre, no_padre, nombre, numero, pelaje1, pelaje2, pelaje3, porcien_cs, propiedad, sexo, tienta_ac, tienta_acCal, tienta_ap, tienta_apCal, ubicacion FROM animal WHERE (CONVERT (VARCHAR(4), ISNULL(no_padre, 0), 0) + ISNULL(ltra_padre, ' ') + CONVERT (VARCHAR(4), ISNULL(ano_padre, 0), 0) LIKE @padre) ORDER BY numero, letra, ano, sexo</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="padre" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@padre" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.animal" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillNombreByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetNombreByID" GeneratorSourceName="FillNombreByID" GetMethodModifier="Public" GetMethodName="GetNombreByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetNombreByID" UserSourceName="FillNombreByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AnimalId, abuelo_mat, ano, ano_madre, ano_padre, arete, cometario, comportamiento, creado, edadmuerto, edadvivo, encaste, estatus, familia, fechabaja, fechanac, fenotipo, hie_madre, hie_padre, hierro, id_madre, id_padre, letra, lidia_ac, lidia_acCal, lidia_ap, lidia_apCal, ltra_madre, ltra_padre, marca1, marca2, marca3, modificado, muerto, no_madre, no_padre, nombre, numero, pelaje1, pelaje2, pelaje3, porcien_cs, propiedad, sexo, tienta_ac, tienta_acCal, tienta_ap, tienta_apCal, ubicacion FROM animal WHERE (AnimalId = @AnimalID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AnimalID" ColumnName="AnimalId" DataSourceName="Ganaderia.dbo.animal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AnimalID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AnimalId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy3" GeneratorSourceName="SQanos" Modifier="Public" Name="SQanos" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="SQanos">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*) AS anos
FROM            animal
WHERE        (propiedad = @propiedad) AND (fechabaja IS NULL) AND (sexo = @sexo) AND (estatus = @estatus) AND (edadVivo BETWEEN @edad1 AND @edad2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="propiedad" ColumnName="propiedad" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@propiedad" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="propiedad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="sexo" ColumnName="sexo" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="char(1)" DbType="AnsiString" Direction="Input" ParameterName="@sexo" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="sexo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="estatus" ColumnName="estatus" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@estatus" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="estatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="edad1" ColumnName="edadVivo" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="numeric(18, 6)" DbType="Decimal" Direction="Input" ParameterName="@edad1" Precision="18" ProviderType="Decimal" Scale="6" Size="9" SourceColumn="edadVivo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="edad2" ColumnName="edadVivo" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="numeric(18, 6)" DbType="Decimal" Direction="Input" ParameterName="@edad2" Precision="18" ProviderType="Decimal" Scale="6" Size="9" SourceColumn="edadVivo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy4" GeneratorSourceName="SQmuertos1" Modifier="Public" Name="SQmuertos1" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="SQmuertos1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*) AS Muertos1
FROM            animal
WHERE        (propiedad = @propiedad) AND (NOT (fechabaja IS NULL)) AND (muerto = @muerto)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="propiedad" ColumnName="propiedad" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@propiedad" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="propiedad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="muerto" ColumnName="muerto" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@muerto" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="muerto" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="SQmuertos2" Modifier="Public" Name="SQmuertos2" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="SQmuertos2">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*) AS Muertos2
FROM            animal
WHERE        (propiedad = @propiedad) AND (NOT (fechabaja IS NULL)) AND (muerto IN ('D', 'O', 'RE'))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="propiedad" ColumnName="propiedad" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@propiedad" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="propiedad" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="SQvivos1" Modifier="Public" Name="SQvivos1" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="SQvivos1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*) AS Vivos1
FROM            animal
WHERE        (propiedad = @propiedad) AND (fechabaja IS NULL) AND (sexo = @sexo) AND (estatus = @estatus)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="propiedad" ColumnName="propiedad" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@propiedad" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="propiedad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="sexo" ColumnName="sexo" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="char(1)" DbType="AnsiString" Direction="Input" ParameterName="@sexo" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="sexo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="estatus" ColumnName="estatus" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@estatus" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="estatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="SQvivos2" Modifier="Public" Name="SQvivos2" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="SQvivos2">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*) AS Vivos2
FROM            animal
WHERE        (propiedad = @propiedad) AND (fechabaja IS NULL) AND (sexo = @sexo) 
AND (estatus IN ('CAB', 'MO', 'MR'))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="propiedad" ColumnName="propiedad" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@propiedad" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="propiedad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="sexo" ColumnName="sexo" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="char(1)" DbType="AnsiString" Direction="Input" ParameterName="@sexo" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="sexo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy2" GeneratorSourceName="SQvivos3" Modifier="Public" Name="SQvivos3" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="SQvivos3">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*) AS Vivos3
FROM            animal
WHERE        (propiedad = @propiedad) AND (fechabaja IS NULL) AND (sexo = @sexo) 
AND (estatus IN ('HO', 'HT'))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="propiedad" ColumnName="propiedad" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@propiedad" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="propiedad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="sexo" ColumnName="sexo" DataSourceName="[C:\USERS\OHERNANDEZ\DOCUMENTS\SANTAFE\APP_DATA\GANADERIA.MDF].dbo.animal" DataTypeServer="char(1)" DbType="AnsiString" Direction="Input" ParameterName="@sexo" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="sexo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="categorias_catalogoTableAdapter" GeneratorDataComponentClassName="categorias_catalogoTableAdapter" Name="categorias_catalogo" UserDataComponentName="categorias_catalogoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.categorias_catalogo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCategorias" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCategorias" GeneratorSourceName="FillCategorias" GetMethodModifier="Public" GetMethodName="GetCategorias" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetCategorias" UserSourceName="FillCategorias">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [categorias_catalogo] WHERE (([cattip] = @Original_cattip))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_cattip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="cattip" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [categorias_catalogo] ([cattip], [catdesc]) VALUES (@cattip, @catdesc)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@cattip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="cattip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@catdesc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="catdesc" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        cattip, catdesc
FROM          categorias_catalogo ORDER BY catdesc</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [categorias_catalogo] SET [cattip] = @cattip, [catdesc] = @catdesc WHERE (([cattip] = @Original_cattip))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@cattip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="cattip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@catdesc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="catdesc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_cattip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="cattip" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cattip" DataSetColumn="cattip" />
              <Mapping SourceColumn="catdesc" DataSetColumn="catdesc" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="catalogo_generalTableAdapter" GeneratorDataComponentClassName="catalogo_generalTableAdapter" Name="catalogo_general" UserDataComponentName="catalogo_generalTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.catalogo_general" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCatGral" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCatGral" GeneratorSourceName="FillCatGral" GetMethodModifier="Public" GetMethodName="GetCatGral" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetCatGral" UserSourceName="FillCatGral">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [catalogo_general] WHERE (([cattip] = @Original_cattip) AND ([catcve] = @Original_catcve))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_cattip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="cattip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_catcve" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="catcve" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [catalogo_general] ([cattip], [catcve], [catnom]) VALUES (@cattip, @catcve, @catnom)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@cattip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="cattip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@catcve" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="catcve" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@catnom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="catnom" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        cattip, catcve, catnom
FROM          catalogo_general</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [catalogo_general] SET [cattip] = @cattip, [catcve] = @catcve, [catnom] = @catnom WHERE (([cattip] = @Original_cattip) AND ([catcve] = @Original_catcve))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@cattip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="cattip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@catcve" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="catcve" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@catnom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="catnom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_cattip" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="cattip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_catcve" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="catcve" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cattip" DataSetColumn="cattip" />
              <Mapping SourceColumn="catcve" DataSetColumn="catcve" />
              <Mapping SourceColumn="catnom" DataSetColumn="catnom" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.catalogo_general" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBycattip" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCatGralBycattip" GeneratorSourceName="FillBycattip" GetMethodModifier="Public" GetMethodName="GetCatGralBycattip" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCatGralBycattip" UserSourceName="FillBycattip">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT catcve, catnom, cattip FROM catalogo_general WHERE (cattip = @cattip) ORDER BY catnom</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="cattip" ColumnName="cattip" DataSourceName="Ganaderia.dbo.catalogo_general" DataTypeServer="char(3)" DbType="AnsiString" Direction="Input" ParameterName="@cattip" Precision="0" ProviderType="Char" Scale="0" Size="3" SourceColumn="cattip" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.catalogo_general" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCatGralByTipCve" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCatGralByTipCve" GeneratorSourceName="FillCatGralByTipCve" GetMethodModifier="Public" GetMethodName="GetCatGralByTipCve" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCatGralByTipCve" UserSourceName="FillCatGralByTipCve">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        catnom, catcve, cattip
FROM            catalogo_general
WHERE        (cattip = @cattip) AND (catcve = @catcve)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="cattip" ColumnName="cattip" DataSourceName="Ganaderia.dbo.catalogo_general" DataTypeServer="char(3)" DbType="AnsiString" Direction="Input" ParameterName="@cattip" Precision="0" ProviderType="Char" Scale="0" Size="3" SourceColumn="cattip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="catcve" ColumnName="catcve" DataSourceName="Ganaderia.dbo.catalogo_general" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@catcve" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="catcve" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Emp_MovsTableAdapter" GeneratorDataComponentClassName="Emp_MovsTableAdapter" Name="Emp_Movs" UserDataComponentName="Emp_MovsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.Emp_Movs" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEmpMov" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEmpMov" GeneratorSourceName="FillEmpMov" GetMethodModifier="Public" GetMethodName="GetEmpMov" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetEmpMov" UserSourceName="FillEmpMov">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM Emp_Movs
WHERE        (empadreId = @Original_EmpadreId) AND (vacaId = @Original_vacaId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_EmpadreId" ColumnName="empadreId" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_EmpadreId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="empadreId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_vacaId" ColumnName="vacaId" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_vacaId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="vacaId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Emp_Movs] ([empadreId], [vaca], [vacaId], [nombre], [ano], [fechaini], [fechafin], [vg_ac], [vg_ap]) VALUES (@empadreId, @vaca, @vacaId, @nombre, @ano, @fechaini, @fechafin, @vg_ac, @vg_ap)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@empadreId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="empadreId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vaca" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vaca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@vacaId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vacaId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@fechaini" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="fechaini" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@fechafin" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="fechafin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@vg_ac" Precision="6" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="vg_ac" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@vg_ap" Precision="6" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="vg_ap" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        empadreId, vaca, vacaId, nombre, ano, fechaini, fechafin, vg_ac, vg_ap
FROM            Emp_Movs</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       Emp_Movs
SET                vaca = @vaca, nombre = @nombre, ano = @ano, fechaini = @fechaini, fechafin = @fechafin, vg_ac = @vg_ac, vg_ap = @vg_ap
WHERE        (empadreId = @Original_EmpadreId) AND (vacaId = @Original_vacaId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="vaca" ColumnName="vaca" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@vaca" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="vaca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="nombre" ColumnName="nombre" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ano" ColumnName="ano" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="fechaini" ColumnName="fechaini" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@fechaini" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="fechaini" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="fechafin" ColumnName="fechafin" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@fechafin" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="fechafin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="vg_ac" ColumnName="vg_ac" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="numeric(6, 3)" DbType="Decimal" Direction="Input" ParameterName="@vg_ac" Precision="6" ProviderType="Decimal" Scale="3" Size="5" SourceColumn="vg_ac" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="vg_ap" ColumnName="vg_ap" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="numeric(6, 3)" DbType="Decimal" Direction="Input" ParameterName="@vg_ap" Precision="6" ProviderType="Decimal" Scale="3" Size="5" SourceColumn="vg_ap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_EmpadreId" ColumnName="empadreId" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_EmpadreId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="empadreId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_vacaId" ColumnName="vacaId" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_vacaId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="vacaId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="empadreId" DataSetColumn="empadreId" />
              <Mapping SourceColumn="vaca" DataSetColumn="vaca" />
              <Mapping SourceColumn="vacaId" DataSetColumn="vacaId" />
              <Mapping SourceColumn="fechaini" DataSetColumn="fechaini" />
              <Mapping SourceColumn="fechafin" DataSetColumn="fechafin" />
              <Mapping SourceColumn="nombre" DataSetColumn="nombre" />
              <Mapping SourceColumn="ano" DataSetColumn="ano" />
              <Mapping SourceColumn="vg_ac" DataSetColumn="vg_ac" />
              <Mapping SourceColumn="vg_ap" DataSetColumn="vg_ap" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="DQ_EmpMov" Modifier="Public" Name="DQ_EmpMov" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DQ_EmpMov">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM Emp_Movs
WHERE        (empadreId = @Original_EmpadreId)
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_EmpadreId" ColumnName="empadreId" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_EmpadreId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="empadreId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.Emp_Movs" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill_EM_ByEmp" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="Get_EM_ByEmp" GeneratorSourceName="Fill_EM_ByEmp" GetMethodModifier="Public" GetMethodName="Get_EM_ByEmp" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="Get_EM_ByEmp" UserSourceName="Fill_EM_ByEmp">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ano, empadreId, fechafin, fechaini, nombre, vaca, vacaId, vg_ac, vg_ap
FROM            Emp_Movs
WHERE        (empadreId = @empadreId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="empadreId" ColumnName="empadreId" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@empadreId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="empadreId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.Emp_Movs" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill_EM_ByEmpAni" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="Get_EM_ByEmpAni" GeneratorSourceName="Fill_EM_ByEmpAni" GetMethodModifier="Public" GetMethodName="Get_EM_ByEmpAni" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="Get_EM_ByEmpAni" UserSourceName="Fill_EM_ByEmpAni">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ano, empadreId, fechafin, fechaini, nombre, vaca, vacaId, vg_ac, vg_ap
FROM            Emp_Movs
WHERE        (empadreId = @empadreId) AND (vacaId = @vacaId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="empadreId" ColumnName="empadreId" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@empadreId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="empadreId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="vacaId" ColumnName="vacaId" DataSourceName="Ganaderia.dbo.Emp_Movs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@vacaId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="vacaId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="empadreTableAdapter" GeneratorDataComponentClassName="empadreTableAdapter" Name="empadre" UserDataComponentName="empadreTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.empadre" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEmpadre" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEmpadre" GeneratorSourceName="FillEmpadre" GetMethodModifier="Public" GetMethodName="GetEmpadre" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetEmpadre" UserSourceName="FillEmpadre">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM empadre
WHERE        (empadreId = @Original_EmpadreId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_EmpadreId" ColumnName="empadreId" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_EmpadreId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="empadreId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [empadre] ([toro], [toroId], [nombre], [ano], [fechaini], [fechafin], [gan_cor], [ubicacion], [estatus]) VALUES (@toro, @toroId, @nombre, @ano, @fechaini, @fechafin, @gan_cor, @ubicacion, @estatus)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@toro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="toro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@toroId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="toroId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@fechaini" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="fechaini" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@fechafin" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="fechafin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@gan_cor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="gan_cor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ubicacion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ubicacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@estatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="estatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        empadreId, toro, toroId, nombre, ano, fechaini, fechafin, gan_cor, ubicacion, estatus
FROM            empadre
ORDER BY   empadreId DESC, fechaini DESC, toro DESC
</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       empadre
SET                toro = @toro, toroId = @toroId, nombre = @nombre, ano = @ano, fechaini = @fechaini, fechafin = @fechafin, gan_cor = @gan_cor, ubicacion = @ubicacion, 
                         estatus = @estatus
WHERE        (empadreId = @Original_empadreId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="toro" ColumnName="toro" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@toro" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="toro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="toroId" ColumnName="toroId" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@toroId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="toroId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="nombre" ColumnName="nombre" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ano" ColumnName="ano" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="fechaini" ColumnName="fechaini" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@fechaini" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="fechaini" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="fechafin" ColumnName="fechafin" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@fechafin" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="fechafin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="gan_cor" ColumnName="gan_cor" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="varchar(1)" DbType="AnsiString" Direction="Input" ParameterName="@gan_cor" Precision="0" ProviderType="VarChar" Scale="0" Size="1" SourceColumn="gan_cor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ubicacion" ColumnName="ubicacion" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@ubicacion" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="ubicacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="estatus" ColumnName="estatus" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="varchar(1)" DbType="AnsiString" Direction="Input" ParameterName="@estatus" Precision="0" ProviderType="VarChar" Scale="0" Size="1" SourceColumn="estatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_empadreId" ColumnName="empadreId" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_empadreId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="empadreId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="empadreId" DataSetColumn="empadreId" />
              <Mapping SourceColumn="toro" DataSetColumn="toro" />
              <Mapping SourceColumn="toroId" DataSetColumn="toroId" />
              <Mapping SourceColumn="fechaini" DataSetColumn="fechaini" />
              <Mapping SourceColumn="fechafin" DataSetColumn="fechafin" />
              <Mapping SourceColumn="gan_cor" DataSetColumn="gan_cor" />
              <Mapping SourceColumn="ubicacion" DataSetColumn="ubicacion" />
              <Mapping SourceColumn="estatus" DataSetColumn="estatus" />
              <Mapping SourceColumn="nombre" DataSetColumn="nombre" />
              <Mapping SourceColumn="ano" DataSetColumn="ano" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.empadre" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FilEmpadreByToro" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEmpadreByToro" GeneratorSourceName="FilEmpadreByToro" GetMethodModifier="Public" GetMethodName="GetEmpadreByToro" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEmpadreByToro" UserSourceName="FilEmpadreByToro">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT empadreId, toro, toroId, nombre, ano, fechaini, fechafin, gan_cor, ubicacion, estatus FROM empadre WHERE (toro LIKE @toro) ORDER BY empadreId DESC, fechaini DESC, toro DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="toro" ColumnName="toro" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@toro" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="toro" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.empadre" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEmpadreByAno" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEmpadreByAno" GeneratorSourceName="FillEmpadreByAno" GetMethodModifier="Public" GetMethodName="GetEmpadreByAno" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEmpadreByAno" UserSourceName="FillEmpadreByAno">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        empadreId, toro, toroId, nombre, ano, fechaini, fechafin, gan_cor, ubicacion, estatus 
FROM       empadre 
WHERE       (ano = @ano) 
ORDER BY    empadreId DESC, fechaini DESC, toro DESC
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ano" ColumnName="ano" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.empadre" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEmpadreByAnoA" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEmpadreByAnoA" GeneratorSourceName="FillEmpadreByAnoA" GetMethodModifier="Public" GetMethodName="GetEmpadreByAnoA" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEmpadreByAnoA" UserSourceName="FillEmpadreByAnoA">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        empadreId, toro, toroId, nombre, ano, fechaini, fechafin, gan_cor, ubicacion, estatus
FROM            dbo.empadre
WHERE        (ano = @ano) AND (estatus = 'A')
ORDER BY empadreId DESC, fechaini DESC, toro DESC
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ano" ColumnName="ano" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.empadre" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEmpadreByAnoN" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEmpadreByAnoN" GeneratorSourceName="FillEmpadreByAnoN" GetMethodModifier="Public" GetMethodName="GetEmpadreByAnoN" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEmpadreByAnoN" UserSourceName="FillEmpadreByAnoN">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        empadreId, toro, toroId, nombre, ano, fechaini, fechafin, gan_cor, ubicacion, estatus
FROM       empadre 
WHERE       (ano = @ano) AND (estatus='N')
ORDER BY    empadreId DESC, fechaini DESC, toro DESC
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ano" ColumnName="ano" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.empadre" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEmpadreByEstatus" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEmpadreByEstatus" GeneratorSourceName="FillEmpadreByEstatus" GetMethodModifier="Public" GetMethodName="GetEmpadreByEstatus" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEmpadreByEstatus" UserSourceName="FillEmpadreByEstatus">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        empadreId, toro, toroId, nombre, ano, fechaini, fechafin, gan_cor, ubicacion, estatus
FROM      empadre 
WHERE    (estatus LIKE @estatus) 
ORDER BY   empadreId DESC, fechaini DESC, toro DESC
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="estatus" ColumnName="estatus" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="varchar(1)" DbType="AnsiString" Direction="Input" ParameterName="@estatus" Precision="0" ProviderType="VarChar" Scale="0" Size="1" SourceColumn="estatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.empadre" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEmpadreById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEmpadreById" GeneratorSourceName="FillEmpadreById" GetMethodModifier="Public" GetMethodName="GetEmpadreById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEmpadreById" UserSourceName="FillEmpadreById">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        empadreId, toro, toroId, nombre, ano, fechaini, fechafin, gan_cor, ubicacion, estatus
FROM       empadre 
WHERE       (empadreId = @empadreId) 
ORDER BY  toro</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="empadreId" ColumnName="empadreId" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@empadreId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="empadreId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.empadre" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEmpadreByUbicacion" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEmpadreByUbicacion" GeneratorSourceName="FillEmpadreByUbicacion" GetMethodModifier="Public" GetMethodName="GetEmpadreByUbicacion" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEmpadreByUbicacion" UserSourceName="FillEmpadreByUbicacion">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        empadreId, toro, toroId, nombre, ano, fechaini, fechafin, gan_cor, ubicacion, estatus
FROM       empadre 
WHERE       (ubicacion LIKE @ubicacion) 
ORDER BY    empadreId DESC, fechaini DESC, toro DESC
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ubicacion" ColumnName="ubicacion" DataSourceName="Ganaderia.dbo.empadre" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@ubicacion" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="ubicacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="SQNumEmp" Modifier="Public" Name="SQNumEmp" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="SQNumEmp">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        MAX(empadreId) AS NumEmp
FROM            empadre</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="valor_genTableAdapter" GeneratorDataComponentClassName="valor_genTableAdapter" Name="valor_gen" UserDataComponentName="valor_genTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.valor_gen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillValor_Gen" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetValor_Gen" GeneratorSourceName="FillValor_Gen" GetMethodModifier="Public" GetMethodName="GetValor_Gen" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetValor_Gen" UserSourceName="FillValor_Gen">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[valor_gen] ([f_alta], [animal], [animalId], [consang], [vg_ac], [e_vg_ac], [vg_ap], [e_vg_ap]) VALUES (@f_alta, @animal, @animalId, @consang, @vg_ac, @e_vg_ac, @vg_ap, @e_vg_ap)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@f_alta" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="f_alta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@animal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="animal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@animalId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="animalId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@consang" Precision="6" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="consang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@vg_ac" Precision="6" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="vg_ac" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@e_vg_ac" Precision="6" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="e_vg_ac" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@vg_ap" Precision="6" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="vg_ap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@e_vg_ap" Precision="6" ProviderType="Decimal" Scale="3" Size="0" SourceColumn="e_vg_ap" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        f_alta, animal, animalId, consang, vg_ac, e_vg_ac, vg_ap, e_vg_ap
FROM            dbo.valor_gen
ORDER BY f_alta, animal</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="f_alta" DataSetColumn="f_alta" />
              <Mapping SourceColumn="animal" DataSetColumn="animal" />
              <Mapping SourceColumn="animalId" DataSetColumn="animalId" />
              <Mapping SourceColumn="consang" DataSetColumn="consang" />
              <Mapping SourceColumn="vg_ac" DataSetColumn="vg_ac" />
              <Mapping SourceColumn="e_vg_ac" DataSetColumn="e_vg_ac" />
              <Mapping SourceColumn="vg_ap" DataSetColumn="vg_ap" />
              <Mapping SourceColumn="e_vg_ap" DataSetColumn="e_vg_ap" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.valor_gen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillValGenByAni" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetValGenByAni" GeneratorSourceName="FillValGenByAni" GetMethodModifier="Public" GetMethodName="GetValGenByAni" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetValGenByAni" UserSourceName="FillValGenByAni">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        TOP (1) f_alta, animal, animalId, consang, vg_ac, e_vg_ac, vg_ap, e_vg_ap
FROM            dbo.valor_gen
WHERE        (animalId = @animalId)
ORDER BY f_alta DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="animalId" ColumnName="animalId" DataSourceName="Ganaderia.dbo.valor_gen" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@animalId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="animalId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="movtosTableAdapter" GeneratorDataComponentClassName="movtosTableAdapter" Name="movtos" UserDataComponentName="movtosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.movtos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillMovtos" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetMovtos" GeneratorSourceName="FillMovtos" GetMethodModifier="Public" GetMethodName="GetMovtos" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetMovtos" UserSourceName="FillMovtos">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [movtos] ([animal], [animalid], [f_captura], [f_movto], [gan_cor], [ubicacion], [empadre], [usuario], [estatus]) VALUES (@animal, @animalid, @f_captura, @f_movto, @gan_cor, @ubicacion, @empadre, @usuario, @estatus)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@animal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="animal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@animalid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="animalid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@f_captura" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="f_captura" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@f_movto" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="f_movto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@gan_cor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="gan_cor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ubicacion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ubicacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@empadre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="empadre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@usuario" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="usuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@estatus" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="estatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        animal, animalid, f_captura, f_movto, gan_cor, ubicacion, empadre, usuario, estatus,
                             (SELECT        nombre
                               FROM            animal
                               WHERE        (AnimalId = movtos.animalid)) AS NomAni, 
                             (SELECT        catnom
                               FROM            catalogo_general
                               WHERE        (cattip = 'U') AND (catcve = movtos.ubicacion)) AS NomUbi
FROM            movtos
</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="animal" DataSetColumn="animal" />
              <Mapping SourceColumn="animalid" DataSetColumn="animalid" />
              <Mapping SourceColumn="f_captura" DataSetColumn="f_captura" />
              <Mapping SourceColumn="f_movto" DataSetColumn="f_movto" />
              <Mapping SourceColumn="gan_cor" DataSetColumn="gan_cor" />
              <Mapping SourceColumn="ubicacion" DataSetColumn="ubicacion" />
              <Mapping SourceColumn="empadre" DataSetColumn="empadre" />
              <Mapping SourceColumn="usuario" DataSetColumn="usuario" />
              <Mapping SourceColumn="estatus" DataSetColumn="estatus" />
              <Mapping SourceColumn="NomAni" DataSetColumn="NomAni" />
              <Mapping SourceColumn="NomUbi" DataSetColumn="NomUbi" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.movtos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEdoByCorral" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEdoByCorral" GeneratorSourceName="FillEdoByCorral" GetMethodModifier="Public" GetMethodName="GetEdoByCorral" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEdoByCorral" UserSourceName="FillEdoByCorral">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        animal, animalid, f_captura, f_movto, gan_cor, ubicacion, empadre, usuario, estatus,
                             (SELECT        nombre
                               FROM            animal
                               WHERE        (AnimalId = movtos.animalid)) AS NomAni,
                             (SELECT        catnom
                               FROM            catalogo_general
                               WHERE        (cattip = 'U') AND (catcve = movtos.ubicacion)) AS NomUbi
FROM            movtos
WHERE        ((SELECT        TOP (1) ubicacion
                            FROM            movtos AS movtos_1
                            WHERE        (animalid = movtos.animalid)
                            ORDER BY f_movto DESC) IN (ubicacion)) AND (ubicacion = @ubicacion)
ORDER BY ubicacion, animalid
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ubicacion" ColumnName="ubicacion" DataSourceName="Ganaderia.dbo.movtos" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@ubicacion" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="ubicacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.movtos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEdoByCorrales" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEdoByCorrales" GeneratorSourceName="FillEdoByCorrales" GetMethodModifier="Public" GetMethodName="GetEdoByCorrales" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEdoByCorrales" UserSourceName="FillEdoByCorrales">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        animal, animalid, f_captura, f_movto, gan_cor, ubicacion, empadre, usuario, estatus,
                             (SELECT        nombre
                               FROM            animal
                               WHERE        (AnimalId = movtos.animalid)) AS NomAni,
                             (SELECT        catnom
                               FROM            catalogo_general
                               WHERE        (cattip = 'U') AND (catcve = movtos.ubicacion)) AS NomUbi
FROM            movtos
WHERE        ((SELECT        TOP (1) ubicacion
                            FROM            movtos AS movtos_1
                            WHERE        (animalid = movtos.animalid)
                            ORDER BY f_movto DESC) IN (ubicacion)) AND (ubicacion &lt;&gt; '')
ORDER BY ubicacion, animalid</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.movtos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEdoByCorrFec" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEdoByCorrFec" GeneratorSourceName="FillEdoByCorrFec" GetMethodModifier="Public" GetMethodName="GetEdoByCorrFec" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEdoByCorrFec" UserSourceName="FillEdoByCorrFec">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        animal, animalid, f_captura, f_movto, gan_cor, ubicacion, empadre, usuario, estatus,
                             (SELECT        nombre
                               FROM            animal
                               WHERE        (AnimalId = movtos.animalid)) AS NomAni,
                             (SELECT        catnom
                               FROM            catalogo_general
                               WHERE        (cattip = 'U') AND (catcve = movtos.ubicacion)) AS NomUbi
FROM            movtos
WHERE        ((SELECT        TOP (1) ubicacion
                            FROM            movtos AS movtos_1
                            WHERE        (animalid = movtos.animalid) AND (f_movto &lt;= CONVERT(date, @f_movto, 103))
                            ORDER BY f_movto DESC) IN (ubicacion)) AND (ubicacion = @ubicacion)
ORDER BY ubicacion, animalid
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ubicacion" ColumnName="ubicacion" DataSourceName="Ganaderia.dbo.movtos" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@ubicacion" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="ubicacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_movto" ColumnName="f_movto" DataSourceName="Ganaderia.dbo.movtos" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@f_movto" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="f_movto" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.movtos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillEdoByFechaM" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEdoByFechaM" GeneratorSourceName="FillEdoByFechaM" GetMethodModifier="Public" GetMethodName="GetEdoByFechaM" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEdoByFechaM" UserSourceName="FillEdoByFechaM">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        animal, animalid, f_captura, f_movto, gan_cor, ubicacion, empadre, usuario, estatus,
                             (SELECT        nombre
                               FROM            animal
                               WHERE        (AnimalId = movtos.animalid)) AS NomAni,
                             (SELECT        catnom
                               FROM            catalogo_general
                               WHERE        (cattip = 'U') AND (catcve = movtos.ubicacion)) AS NomUbi
FROM            movtos
WHERE        ((SELECT        TOP (1) ubicacion
                            FROM            movtos AS movtos_1
                            WHERE        (animalid = movtos.animalid) AND (f_movto &lt;= CONVERT(date, @f_movto, 103))
                            ORDER BY f_movto DESC) IN (ubicacion)) AND (ubicacion &lt;&gt; '')
ORDER BY ubicacion, animalid</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="f_movto" ColumnName="f_movto" DataSourceName="Ganaderia.dbo.movtos" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@f_movto" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="f_movto" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.movtos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillMovtosByEstatus" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetMovtosByEstatus" GeneratorSourceName="FillMovtosByEstatus" GetMethodModifier="Public" GetMethodName="GetMovtosByEstatus" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetMovtosByEstatus" UserSourceName="FillMovtosByEstatus">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        animal, animalid, f_captura, f_movto, gan_cor, ubicacion, empadre, usuario, estatus,
                             (SELECT        nombre
                               FROM            animal
                               WHERE        (AnimalId = movtos.animalid)) AS NomAni, 
                             (SELECT        catnom
                               FROM            catalogo_general
                               WHERE        (cattip = 'U') AND (catcve = movtos.ubicacion)) AS NomUbi
FROM            movtos
WHERE (estatus = @estatus)
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="estatus" ColumnName="estatus" DataSourceName="Ganaderia.dbo.movtos" DataTypeServer="char(1)" DbType="AnsiString" Direction="Input" ParameterName="@estatus" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="estatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.movtos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillMovtosByFecha" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetMovtosByFecha" GeneratorSourceName="FillMovtosByFecha" GetMethodModifier="Public" GetMethodName="GetMovtosByFecha" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetMovtosByFecha" UserSourceName="FillMovtosByFecha">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        animal, animalid, f_captura, f_movto, gan_cor, ubicacion, empadre, usuario, estatus,
                             (SELECT        nombre
                               FROM            animal
                               WHERE        (AnimalId = movtos.animalid)) AS NomAni, 
                             (SELECT        catnom
                               FROM            catalogo_general
                               WHERE        (cattip = 'U') AND (catcve = movtos.ubicacion)) AS NomUbi
FROM            movtos
WHERE (f_movto BETWEEN @f_ini AND @f_fin)
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="f_ini" ColumnName="f_movto" DataSourceName="Ganaderia.dbo.movtos" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@f_ini" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="f_movto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_fin" ColumnName="f_movto" DataSourceName="Ganaderia.dbo.movtos" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@f_fin" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="f_movto" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.movtos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillMovtosById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetMovtosById" GeneratorSourceName="FillMovtosById" GetMethodModifier="Public" GetMethodName="GetMovtosById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetMovtosById" UserSourceName="FillMovtosById">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        animal, animalid, f_captura, f_movto, gan_cor, ubicacion, empadre, usuario, estatus,
                             (SELECT        nombre
                               FROM            animal
                               WHERE        (AnimalId = movtos.animalid)) AS NomAni, 
                             (SELECT        catnom
                               FROM            catalogo_general
                               WHERE        (cattip = 'U') AND (catcve = movtos.ubicacion)) AS NomUbi
FROM            movtos
WHERE (animalId = @animalId)
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="animalId" ColumnName="animalid" DataSourceName="Ganaderia.dbo.movtos" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@animalId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="animalid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.movtos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillMovtosByUbic" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetMovtosByUbic" GeneratorSourceName="FillMovtosByUbic" GetMethodModifier="Public" GetMethodName="GetMovtosByUbic" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetMovtosByUbic" UserSourceName="FillMovtosByUbic">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        animal, animalid, f_captura, f_movto, gan_cor, ubicacion, empadre, usuario, estatus,
                             (SELECT        nombre
                               FROM            animal
                               WHERE        (AnimalId = movtos.animalid)) AS NomAni, 
                             (SELECT        catnom
                               FROM            catalogo_general
                               WHERE        (cattip = 'U') AND (catcve = movtos.ubicacion)) AS NomUbi
FROM            movtos
WHERE (ubicacion = @ubicacion)
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ubicacion" ColumnName="ubicacion" DataSourceName="Ganaderia.dbo.movtos" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@ubicacion" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="ubicacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="movtos2TableAdapter" GeneratorDataComponentClassName="movtos2TableAdapter" Name="movtos2" UserDataComponentName="movtos2TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.movtos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillMovtos2" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetMovtos2" GeneratorSourceName="FillMovtos2" GetMethodModifier="Public" GetMethodName="GetMovtos2" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetMovtos2" UserSourceName="FillMovtos2">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        animal, animalid,
                             (SELECT        nombre
                               FROM            animal
                               WHERE        (AnimalId = movtos.animalid)) AS Nombre,
                             (SELECT        sexo
                               FROM            animal AS animal_2
                               WHERE        (AnimalId = movtos.animalid)) AS Sx, COUNT(DISTINCT ubicacion) AS veces
FROM            movtos
GROUP BY animal, animalid</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="animal" DataSetColumn="animal" />
              <Mapping SourceColumn="animalid" DataSetColumn="animalid" />
              <Mapping SourceColumn="veces" DataSetColumn="veces" />
              <Mapping SourceColumn="Nombre" DataSetColumn="Nombre" />
              <Mapping SourceColumn="Sx" DataSetColumn="Sx" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="GanaderiaConnectionString (Web.config)" DbObjectName="Ganaderia.dbo.movtos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillMovsBySexo" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetMovsBySexo" GeneratorSourceName="FillMovsBySexo" GetMethodModifier="Public" GetMethodName="GetMovsBySexo" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetMovsBySexo" UserSourceName="FillMovsBySexo">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        animal, animalid,
                             (SELECT        nombre
                               FROM            animal AS animal_1
                               WHERE        (AnimalId = movtos.animalid)) AS Nombre,
                             (SELECT        sexo
                               FROM            animal AS animal_2
                               WHERE        (AnimalId = movtos.animalid)) AS Sx, COUNT(animal) AS veces
FROM            movtos
WHERE        (animalid =
                             (SELECT        AnimalId
                               FROM            animal AS animal_3
                               WHERE        (AnimalId = movtos.animalid) AND (sexo = @sexo)))
GROUP BY animal, animalid</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="sexo" ColumnName="" DataSourceName="" DataTypeServer="char(1)" DbType="AnsiString" Direction="Input" ParameterName="@sexo" Precision="0" Scale="0" Size="1" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet_ohl" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DataSet_ohl" msprop:Generator_DataSetName="DataSet_ohl">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="animal" msprop:Generator_UserTableName="animal" msprop:Generator_RowDeletedName="animalRowDeleted" msprop:Generator_RowChangedName="animalRowChanged" msprop:Generator_RowClassName="animalRow" msprop:Generator_RowChangingName="animalRowChanging" msprop:Generator_RowEvArgName="animalRowChangeEvent" msprop:Generator_RowEvHandlerName="animalRowChangeEventHandler" msprop:Generator_TableClassName="animalDataTable" msprop:Generator_TableVarName="tableanimal" msprop:Generator_RowDeletingName="animalRowDeleting" msprop:Generator_TablePropName="animal">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AnimalId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="AnimalId" msprop:Generator_ColumnVarNameInTable="columnAnimalId" msprop:Generator_ColumnPropNameInRow="AnimalId" msprop:Generator_ColumnPropNameInTable="AnimalIdColumn" type="xs:int" />
              <xs:element name="sexo" msprop:Generator_UserColumnName="sexo" msprop:Generator_ColumnVarNameInTable="columnsexo" msprop:Generator_ColumnPropNameInRow="sexo" msprop:Generator_ColumnPropNameInTable="sexoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="numero" msprop:Generator_UserColumnName="numero" msprop:Generator_ColumnVarNameInTable="columnnumero" msprop:Generator_ColumnPropNameInRow="numero" msprop:Generator_ColumnPropNameInTable="numeroColumn" type="xs:int" />
              <xs:element name="letra" msprop:Generator_UserColumnName="letra" msprop:Generator_ColumnVarNameInTable="columnletra" msprop:Generator_ColumnPropNameInRow="letra" msprop:Generator_ColumnPropNameInTable="letraColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ano" msprop:Generator_UserColumnName="ano" msprop:Generator_ColumnVarNameInTable="columnano" msprop:Generator_ColumnPropNameInRow="ano" msprop:Generator_ColumnPropNameInTable="anoColumn" type="xs:int" />
              <xs:element name="nombre" msprop:Generator_UserColumnName="nombre" msprop:Generator_ColumnVarNameInTable="columnnombre" msprop:Generator_ColumnPropNameInRow="nombre" msprop:Generator_ColumnPropNameInTable="nombreColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fechanac" msprop:Generator_UserColumnName="fechanac" msprop:Generator_ColumnVarNameInTable="columnfechanac" msprop:Generator_ColumnPropNameInRow="fechanac" msprop:Generator_ColumnPropNameInTable="fechanacColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="hierro" msprop:Generator_UserColumnName="hierro" msprop:Generator_ColumnVarNameInTable="columnhierro" msprop:Generator_ColumnPropNameInRow="hierro" msprop:Generator_ColumnPropNameInTable="hierroColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="propiedad" msprop:Generator_UserColumnName="propiedad" msprop:Generator_ColumnVarNameInTable="columnpropiedad" msprop:Generator_ColumnPropNameInRow="propiedad" msprop:Generator_ColumnPropNameInTable="propiedadColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="encaste" msprop:Generator_UserColumnName="encaste" msprop:Generator_ColumnVarNameInTable="columnencaste" msprop:Generator_ColumnPropNameInRow="encaste" msprop:Generator_ColumnPropNameInTable="encasteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="familia" msprop:Generator_UserColumnName="familia" msprop:Generator_ColumnVarNameInTable="columnfamilia" msprop:Generator_ColumnPropNameInRow="familia" msprop:Generator_ColumnPropNameInTable="familiaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="arete" msprop:Generator_UserColumnName="arete" msprop:Generator_ColumnVarNameInTable="columnarete" msprop:Generator_ColumnPropNameInRow="arete" msprop:Generator_ColumnPropNameInTable="areteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="no_padre" msprop:Generator_UserColumnName="no_padre" msprop:Generator_ColumnVarNameInTable="columnno_padre" msprop:Generator_ColumnPropNameInRow="no_padre" msprop:Generator_ColumnPropNameInTable="no_padreColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ltra_padre" msprop:Generator_UserColumnName="ltra_padre" msprop:Generator_ColumnVarNameInTable="columnltra_padre" msprop:Generator_ColumnPropNameInRow="ltra_padre" msprop:Generator_ColumnPropNameInTable="ltra_padreColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ano_padre" msprop:Generator_UserColumnName="ano_padre" msprop:Generator_ColumnVarNameInTable="columnano_padre" msprop:Generator_ColumnPropNameInRow="ano_padre" msprop:Generator_ColumnPropNameInTable="ano_padreColumn" type="xs:int" minOccurs="0" />
              <xs:element name="hie_padre" msprop:Generator_UserColumnName="hie_padre" msprop:Generator_ColumnVarNameInTable="columnhie_padre" msprop:Generator_ColumnPropNameInRow="hie_padre" msprop:Generator_ColumnPropNameInTable="hie_padreColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id_padre" msprop:Generator_UserColumnName="id_padre" msprop:Generator_ColumnVarNameInTable="columnid_padre" msprop:Generator_ColumnPropNameInRow="id_padre" msprop:Generator_ColumnPropNameInTable="id_padreColumn" type="xs:int" minOccurs="0" />
              <xs:element name="no_madre" msprop:Generator_UserColumnName="no_madre" msprop:Generator_ColumnVarNameInTable="columnno_madre" msprop:Generator_ColumnPropNameInRow="no_madre" msprop:Generator_ColumnPropNameInTable="no_madreColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ltra_madre" msprop:Generator_UserColumnName="ltra_madre" msprop:Generator_ColumnVarNameInTable="columnltra_madre" msprop:Generator_ColumnPropNameInRow="ltra_madre" msprop:Generator_ColumnPropNameInTable="ltra_madreColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ano_madre" msprop:Generator_UserColumnName="ano_madre" msprop:Generator_ColumnVarNameInTable="columnano_madre" msprop:Generator_ColumnPropNameInRow="ano_madre" msprop:Generator_ColumnPropNameInTable="ano_madreColumn" type="xs:int" minOccurs="0" />
              <xs:element name="hie_madre" msprop:Generator_UserColumnName="hie_madre" msprop:Generator_ColumnVarNameInTable="columnhie_madre" msprop:Generator_ColumnPropNameInRow="hie_madre" msprop:Generator_ColumnPropNameInTable="hie_madreColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id_madre" msprop:Generator_UserColumnName="id_madre" msprop:Generator_ColumnVarNameInTable="columnid_madre" msprop:Generator_ColumnPropNameInRow="id_madre" msprop:Generator_ColumnPropNameInTable="id_madreColumn" type="xs:int" minOccurs="0" />
              <xs:element name="abuelo_mat" msprop:Generator_UserColumnName="abuelo_mat" msprop:Generator_ColumnVarNameInTable="columnabuelo_mat" msprop:Generator_ColumnPropNameInRow="abuelo_mat" msprop:Generator_ColumnPropNameInTable="abuelo_matColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ubicacion" msprop:Generator_UserColumnName="ubicacion" msprop:Generator_ColumnVarNameInTable="columnubicacion" msprop:Generator_ColumnPropNameInRow="ubicacion" msprop:Generator_ColumnPropNameInTable="ubicacionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="estatus" msprop:Generator_UserColumnName="estatus" msprop:Generator_ColumnVarNameInTable="columnestatus" msprop:Generator_ColumnPropNameInRow="estatus" msprop:Generator_ColumnPropNameInTable="estatusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="muerto" msprop:Generator_UserColumnName="muerto" msprop:Generator_ColumnVarNameInTable="columnmuerto" msprop:Generator_ColumnPropNameInRow="muerto" msprop:Generator_ColumnPropNameInTable="muertoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fechabaja" msprop:Generator_UserColumnName="fechabaja" msprop:Generator_ColumnVarNameInTable="columnfechabaja" msprop:Generator_ColumnPropNameInRow="fechabaja" msprop:Generator_ColumnPropNameInTable="fechabajaColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="lidia_acCal" msprop:Generator_UserColumnName="lidia_acCal" msprop:Generator_ColumnVarNameInTable="columnlidia_acCal" msprop:Generator_ColumnPropNameInRow="lidia_acCal" msprop:Generator_ColumnPropNameInTable="lidia_acCalColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lidia_apCal" msprop:Generator_UserColumnName="lidia_apCal" msprop:Generator_ColumnVarNameInTable="columnlidia_apCal" msprop:Generator_ColumnPropNameInRow="lidia_apCal" msprop:Generator_ColumnPropNameInTable="lidia_apCalColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lidia_ac" msprop:Generator_UserColumnName="lidia_ac" msprop:Generator_ColumnVarNameInTable="columnlidia_ac" msprop:Generator_ColumnPropNameInRow="lidia_ac" msprop:Generator_ColumnPropNameInTable="lidia_acColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lidia_ap" msprop:Generator_UserColumnName="lidia_ap" msprop:Generator_ColumnVarNameInTable="columnlidia_ap" msprop:Generator_ColumnPropNameInRow="lidia_ap" msprop:Generator_ColumnPropNameInTable="lidia_apColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tienta_acCal" msprop:Generator_UserColumnName="tienta_acCal" msprop:Generator_ColumnVarNameInTable="columntienta_acCal" msprop:Generator_ColumnPropNameInRow="tienta_acCal" msprop:Generator_ColumnPropNameInTable="tienta_acCalColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tienta_apCal" msprop:Generator_UserColumnName="tienta_apCal" msprop:Generator_ColumnVarNameInTable="columntienta_apCal" msprop:Generator_ColumnPropNameInRow="tienta_apCal" msprop:Generator_ColumnPropNameInTable="tienta_apCalColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tienta_ac" msprop:Generator_UserColumnName="tienta_ac" msprop:Generator_ColumnVarNameInTable="columntienta_ac" msprop:Generator_ColumnPropNameInRow="tienta_ac" msprop:Generator_ColumnPropNameInTable="tienta_acColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tienta_ap" msprop:Generator_UserColumnName="tienta_ap" msprop:Generator_ColumnVarNameInTable="columntienta_ap" msprop:Generator_ColumnPropNameInRow="tienta_ap" msprop:Generator_ColumnPropNameInTable="tienta_apColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="porcien_cs" msprop:Generator_UserColumnName="porcien_cs" msprop:Generator_ColumnVarNameInTable="columnporcien_cs" msprop:Generator_ColumnPropNameInRow="porcien_cs" msprop:Generator_ColumnPropNameInTable="porcien_csColumn" type="xs:double" minOccurs="0" />
              <xs:element name="fenotipo" msprop:Generator_UserColumnName="fenotipo" msprop:Generator_ColumnVarNameInTable="columnfenotipo" msprop:Generator_ColumnPropNameInRow="fenotipo" msprop:Generator_ColumnPropNameInTable="fenotipoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="comportamiento" msprop:Generator_UserColumnName="comportamiento" msprop:Generator_ColumnVarNameInTable="columncomportamiento" msprop:Generator_ColumnPropNameInRow="comportamiento" msprop:Generator_ColumnPropNameInTable="comportamientoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="marca1" msprop:Generator_UserColumnName="marca1" msprop:Generator_ColumnVarNameInTable="columnmarca1" msprop:Generator_ColumnPropNameInRow="marca1" msprop:Generator_ColumnPropNameInTable="marca1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="marca2" msprop:Generator_UserColumnName="marca2" msprop:Generator_ColumnVarNameInTable="columnmarca2" msprop:Generator_ColumnPropNameInRow="marca2" msprop:Generator_ColumnPropNameInTable="marca2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="marca3" msprop:Generator_UserColumnName="marca3" msprop:Generator_ColumnVarNameInTable="columnmarca3" msprop:Generator_ColumnPropNameInRow="marca3" msprop:Generator_ColumnPropNameInTable="marca3Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pelaje1" msprop:Generator_UserColumnName="pelaje1" msprop:Generator_ColumnVarNameInTable="columnpelaje1" msprop:Generator_ColumnPropNameInRow="pelaje1" msprop:Generator_ColumnPropNameInTable="pelaje1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pelaje2" msprop:Generator_UserColumnName="pelaje2" msprop:Generator_ColumnVarNameInTable="columnpelaje2" msprop:Generator_ColumnPropNameInRow="pelaje2" msprop:Generator_ColumnPropNameInTable="pelaje2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pelaje3" msprop:Generator_UserColumnName="pelaje3" msprop:Generator_ColumnVarNameInTable="columnpelaje3" msprop:Generator_ColumnPropNameInRow="pelaje3" msprop:Generator_ColumnPropNameInTable="pelaje3Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cometario" msprop:Generator_UserColumnName="cometario" msprop:Generator_ColumnVarNameInTable="columncometario" msprop:Generator_ColumnPropNameInRow="cometario" msprop:Generator_ColumnPropNameInTable="cometarioColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="creado" msprop:Generator_UserColumnName="creado" msprop:Generator_ColumnVarNameInTable="columncreado" msprop:Generator_ColumnPropNameInRow="creado" msprop:Generator_ColumnPropNameInTable="creadoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="modificado" msprop:Generator_UserColumnName="modificado" msprop:Generator_ColumnVarNameInTable="columnmodificado" msprop:Generator_ColumnPropNameInRow="modificado" msprop:Generator_ColumnPropNameInTable="modificadoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="edadvivo" msdata:ReadOnly="true" msprop:Generator_UserColumnName="edadvivo" msprop:Generator_ColumnVarNameInTable="columnedadvivo" msprop:Generator_ColumnPropNameInRow="edadvivo" msprop:Generator_ColumnPropNameInTable="edadvivoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="edadmuerto" msdata:ReadOnly="true" msprop:Generator_UserColumnName="edadmuerto" msprop:Generator_ColumnVarNameInTable="columnedadmuerto" msprop:Generator_ColumnPropNameInRow="edadmuerto" msprop:Generator_ColumnPropNameInTable="edadmuertoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="edadvivo1" msdata:ReadOnly="true" msdata:Caption="edadvivo" msprop:Generator_UserColumnName="edadvivo1" msprop:Generator_ColumnVarNameInTable="columnedadvivo1" msprop:Generator_ColumnPropNameInRow="edadvivo1" msprop:Generator_ColumnPropNameInTable="edadvivo1Column" type="xs:decimal" minOccurs="0" />
              <xs:element name="edadmuerto1" msdata:ReadOnly="true" msdata:Caption="edadmuerto" msprop:Generator_UserColumnName="edadmuerto1" msprop:Generator_ColumnVarNameInTable="columnedadmuerto1" msprop:Generator_ColumnPropNameInRow="edadmuerto1" msprop:Generator_ColumnPropNameInTable="edadmuerto1Column" type="xs:decimal" minOccurs="0" />
              <xs:element name="cve_snla" msdata:ReadOnly="true" msdata:Expression="sexo+numero+letra+ano" msprop:Generator_UserColumnName="cve_snla" msprop:Generator_ColumnPropNameInRow="cve_snla" msprop:Generator_ColumnVarNameInTable="columncve_snla" msprop:Generator_ColumnPropNameInTable="cve_snlaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cveAnimal" msdata:ReadOnly="true" msprop:Generator_UserColumnName="cveAnimal" msprop:Generator_ColumnVarNameInTable="columncveAnimal" msprop:Generator_ColumnPropNameInRow="cveAnimal" msprop:Generator_ColumnPropNameInTable="cveAnimalColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="categorias_catalogo" msprop:Generator_UserTableName="categorias_catalogo" msprop:Generator_RowDeletedName="categorias_catalogoRowDeleted" msprop:Generator_RowChangedName="categorias_catalogoRowChanged" msprop:Generator_RowClassName="categorias_catalogoRow" msprop:Generator_RowChangingName="categorias_catalogoRowChanging" msprop:Generator_RowEvArgName="categorias_catalogoRowChangeEvent" msprop:Generator_RowEvHandlerName="categorias_catalogoRowChangeEventHandler" msprop:Generator_TableClassName="categorias_catalogoDataTable" msprop:Generator_TableVarName="tablecategorias_catalogo" msprop:Generator_RowDeletingName="categorias_catalogoRowDeleting" msprop:Generator_TablePropName="categorias_catalogo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cattip" msprop:Generator_UserColumnName="cattip" msprop:Generator_ColumnVarNameInTable="columncattip" msprop:Generator_ColumnPropNameInRow="cattip" msprop:Generator_ColumnPropNameInTable="cattipColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="catdesc" msprop:Generator_UserColumnName="catdesc" msprop:Generator_ColumnVarNameInTable="columncatdesc" msprop:Generator_ColumnPropNameInRow="catdesc" msprop:Generator_ColumnPropNameInTable="catdescColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="catalogo_general" msprop:Generator_UserTableName="catalogo_general" msprop:Generator_RowDeletedName="catalogo_generalRowDeleted" msprop:Generator_RowChangedName="catalogo_generalRowChanged" msprop:Generator_RowClassName="catalogo_generalRow" msprop:Generator_RowChangingName="catalogo_generalRowChanging" msprop:Generator_RowEvArgName="catalogo_generalRowChangeEvent" msprop:Generator_RowEvHandlerName="catalogo_generalRowChangeEventHandler" msprop:Generator_TableClassName="catalogo_generalDataTable" msprop:Generator_TableVarName="tablecatalogo_general" msprop:Generator_RowDeletingName="catalogo_generalRowDeleting" msprop:Generator_TablePropName="catalogo_general">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cattip" msprop:Generator_UserColumnName="cattip" msprop:Generator_ColumnPropNameInRow="cattip" msprop:Generator_ColumnVarNameInTable="columncattip" msprop:Generator_ColumnPropNameInTable="cattipColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="catcve" msprop:Generator_UserColumnName="catcve" msprop:Generator_ColumnPropNameInRow="catcve" msprop:Generator_ColumnVarNameInTable="columncatcve" msprop:Generator_ColumnPropNameInTable="catcveColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="catnom" msprop:Generator_UserColumnName="catnom" msprop:Generator_ColumnPropNameInRow="catnom" msprop:Generator_ColumnVarNameInTable="columncatnom" msprop:Generator_ColumnPropNameInTable="catnomColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Emp_Movs" msprop:Generator_UserTableName="Emp_Movs" msprop:Generator_RowDeletedName="Emp_MovsRowDeleted" msprop:Generator_RowChangedName="Emp_MovsRowChanged" msprop:Generator_RowClassName="Emp_MovsRow" msprop:Generator_RowChangingName="Emp_MovsRowChanging" msprop:Generator_RowEvArgName="Emp_MovsRowChangeEvent" msprop:Generator_RowEvHandlerName="Emp_MovsRowChangeEventHandler" msprop:Generator_TableClassName="Emp_MovsDataTable" msprop:Generator_TableVarName="tableEmp_Movs" msprop:Generator_RowDeletingName="Emp_MovsRowDeleting" msprop:Generator_TablePropName="Emp_Movs">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="empadreId" msprop:Generator_UserColumnName="empadreId" msprop:Generator_ColumnPropNameInRow="empadreId" msprop:Generator_ColumnVarNameInTable="columnempadreId" msprop:Generator_ColumnPropNameInTable="empadreIdColumn" type="xs:int" />
              <xs:element name="vaca" msprop:Generator_UserColumnName="vaca" msprop:Generator_ColumnPropNameInRow="vaca" msprop:Generator_ColumnVarNameInTable="columnvaca" msprop:Generator_ColumnPropNameInTable="vacaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vacaId" msprop:Generator_UserColumnName="vacaId" msprop:Generator_ColumnPropNameInRow="vacaId" msprop:Generator_ColumnVarNameInTable="columnvacaId" msprop:Generator_ColumnPropNameInTable="vacaIdColumn" type="xs:int" />
              <xs:element name="nombre" msprop:Generator_UserColumnName="nombre" msprop:Generator_ColumnPropNameInRow="nombre" msprop:Generator_ColumnVarNameInTable="columnnombre" msprop:Generator_ColumnPropNameInTable="nombreColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fechaini" msprop:Generator_UserColumnName="fechaini" msprop:Generator_ColumnPropNameInRow="fechaini" msprop:Generator_ColumnVarNameInTable="columnfechaini" msprop:Generator_ColumnPropNameInTable="fechainiColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="fechafin" msprop:Generator_UserColumnName="fechafin" msprop:Generator_ColumnPropNameInRow="fechafin" msprop:Generator_ColumnVarNameInTable="columnfechafin" msprop:Generator_ColumnPropNameInTable="fechafinColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ano" msprop:Generator_UserColumnName="ano" msprop:Generator_ColumnPropNameInRow="ano" msprop:Generator_ColumnVarNameInTable="columnano" msprop:Generator_ColumnPropNameInTable="anoColumn" type="xs:int" />
              <xs:element name="vg_ac" msprop:Generator_UserColumnName="vg_ac" msprop:Generator_ColumnPropNameInRow="vg_ac" msprop:Generator_ColumnVarNameInTable="columnvg_ac" msprop:Generator_ColumnPropNameInTable="vg_acColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="vg_ap" msprop:Generator_UserColumnName="vg_ap" msprop:Generator_ColumnPropNameInRow="vg_ap" msprop:Generator_ColumnVarNameInTable="columnvg_ap" msprop:Generator_ColumnPropNameInTable="vg_apColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="empadre" msprop:Generator_UserTableName="empadre" msprop:Generator_RowDeletedName="empadreRowDeleted" msprop:Generator_RowChangedName="empadreRowChanged" msprop:Generator_RowClassName="empadreRow" msprop:Generator_RowChangingName="empadreRowChanging" msprop:Generator_RowEvArgName="empadreRowChangeEvent" msprop:Generator_RowEvHandlerName="empadreRowChangeEventHandler" msprop:Generator_TableClassName="empadreDataTable" msprop:Generator_TableVarName="tableempadre" msprop:Generator_RowDeletingName="empadreRowDeleting" msprop:Generator_TablePropName="empadre">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="empadreId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="empadreId" msprop:Generator_ColumnVarNameInTable="columnempadreId" msprop:Generator_ColumnPropNameInRow="empadreId" msprop:Generator_ColumnPropNameInTable="empadreIdColumn" type="xs:int" />
              <xs:element name="toro" msprop:Generator_UserColumnName="toro" msprop:Generator_ColumnVarNameInTable="columntoro" msprop:Generator_ColumnPropNameInRow="toro" msprop:Generator_ColumnPropNameInTable="toroColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="toroId" msprop:Generator_UserColumnName="toroId" msprop:Generator_ColumnVarNameInTable="columntoroId" msprop:Generator_ColumnPropNameInRow="toroId" msprop:Generator_ColumnPropNameInTable="toroIdColumn" type="xs:int" />
              <xs:element name="fechaini" msprop:Generator_UserColumnName="fechaini" msprop:nullValue="_throw" msprop:Generator_ColumnPropNameInRow="fechaini" msprop:Generator_ColumnPropNameInTable="fechainiColumn" msprop:Generator_ColumnVarNameInTable="columnfechaini" type="xs:dateTime" minOccurs="0" />
              <xs:element name="fechafin" msprop:Generator_UserColumnName="fechafin" msprop:Generator_ColumnVarNameInTable="columnfechafin" msprop:Generator_ColumnPropNameInRow="fechafin" msprop:Generator_ColumnPropNameInTable="fechafinColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="gan_cor" msprop:Generator_UserColumnName="gan_cor" msprop:Generator_ColumnVarNameInTable="columngan_cor" msprop:Generator_ColumnPropNameInRow="gan_cor" msprop:Generator_ColumnPropNameInTable="gan_corColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ubicacion" msprop:Generator_UserColumnName="ubicacion" msprop:Generator_ColumnVarNameInTable="columnubicacion" msprop:Generator_ColumnPropNameInRow="ubicacion" msprop:Generator_ColumnPropNameInTable="ubicacionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="estatus" msprop:Generator_UserColumnName="estatus" msprop:Generator_ColumnVarNameInTable="columnestatus" msprop:Generator_ColumnPropNameInRow="estatus" msprop:Generator_ColumnPropNameInTable="estatusColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nombre" msprop:Generator_UserColumnName="nombre" msprop:Generator_ColumnVarNameInTable="columnnombre" msprop:Generator_ColumnPropNameInRow="nombre" msprop:Generator_ColumnPropNameInTable="nombreColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ano" msprop:Generator_UserColumnName="ano" msprop:Generator_ColumnVarNameInTable="columnano" msprop:Generator_ColumnPropNameInRow="ano" msprop:Generator_ColumnPropNameInTable="anoColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="valor_gen" msprop:Generator_UserTableName="valor_gen" msprop:Generator_RowDeletedName="valor_genRowDeleted" msprop:Generator_RowChangedName="valor_genRowChanged" msprop:Generator_RowClassName="valor_genRow" msprop:Generator_RowChangingName="valor_genRowChanging" msprop:Generator_RowEvArgName="valor_genRowChangeEvent" msprop:Generator_RowEvHandlerName="valor_genRowChangeEventHandler" msprop:Generator_TableClassName="valor_genDataTable" msprop:Generator_TableVarName="tablevalor_gen" msprop:Generator_RowDeletingName="valor_genRowDeleting" msprop:Generator_TablePropName="valor_gen">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="f_alta" msprop:Generator_UserColumnName="f_alta" msprop:Generator_ColumnVarNameInTable="columnf_alta" msprop:Generator_ColumnPropNameInRow="f_alta" msprop:Generator_ColumnPropNameInTable="f_altaColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="animal" msprop:Generator_UserColumnName="animal" msprop:Generator_ColumnVarNameInTable="columnanimal" msprop:Generator_ColumnPropNameInRow="animal" msprop:Generator_ColumnPropNameInTable="animalColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="animalId" msprop:Generator_UserColumnName="animalId" msprop:Generator_ColumnVarNameInTable="columnanimalId" msprop:Generator_ColumnPropNameInRow="animalId" msprop:Generator_ColumnPropNameInTable="animalIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="consang" msprop:Generator_UserColumnName="consang" msprop:Generator_ColumnVarNameInTable="columnconsang" msprop:Generator_ColumnPropNameInRow="consang" msprop:Generator_ColumnPropNameInTable="consangColumn" type="xs:decimal" />
              <xs:element name="vg_ac" msprop:Generator_UserColumnName="vg_ac" msprop:Generator_ColumnVarNameInTable="columnvg_ac" msprop:Generator_ColumnPropNameInRow="vg_ac" msprop:Generator_ColumnPropNameInTable="vg_acColumn" type="xs:decimal" />
              <xs:element name="e_vg_ac" msprop:Generator_UserColumnName="e_vg_ac" msprop:Generator_ColumnVarNameInTable="columne_vg_ac" msprop:Generator_ColumnPropNameInRow="e_vg_ac" msprop:Generator_ColumnPropNameInTable="e_vg_acColumn" type="xs:decimal" />
              <xs:element name="vg_ap" msprop:Generator_UserColumnName="vg_ap" msprop:Generator_ColumnVarNameInTable="columnvg_ap" msprop:Generator_ColumnPropNameInRow="vg_ap" msprop:Generator_ColumnPropNameInTable="vg_apColumn" type="xs:decimal" />
              <xs:element name="e_vg_ap" msprop:Generator_UserColumnName="e_vg_ap" msprop:Generator_ColumnVarNameInTable="columne_vg_ap" msprop:Generator_ColumnPropNameInRow="e_vg_ap" msprop:Generator_ColumnPropNameInTable="e_vg_apColumn" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="movtos" msprop:Generator_UserTableName="movtos" msprop:Generator_RowDeletedName="movtosRowDeleted" msprop:Generator_RowChangedName="movtosRowChanged" msprop:Generator_RowClassName="movtosRow" msprop:Generator_RowChangingName="movtosRowChanging" msprop:Generator_RowEvArgName="movtosRowChangeEvent" msprop:Generator_RowEvHandlerName="movtosRowChangeEventHandler" msprop:Generator_TableClassName="movtosDataTable" msprop:Generator_TableVarName="tablemovtos" msprop:Generator_RowDeletingName="movtosRowDeleting" msprop:Generator_TablePropName="movtos">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="animal" msprop:Generator_UserColumnName="animal" msprop:nullValue="_throw" msprop:Generator_ColumnVarNameInTable="columnanimal" msprop:Generator_ColumnPropNameInTable="animalColumn" msprop:Generator_ColumnPropNameInRow="animal">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="animalid" msprop:Generator_UserColumnName="animalid" msprop:Generator_ColumnVarNameInTable="columnanimalid" msprop:Generator_ColumnPropNameInRow="animalid" msprop:Generator_ColumnPropNameInTable="animalidColumn" type="xs:int" />
              <xs:element name="f_captura" msprop:Generator_UserColumnName="f_captura" msprop:Generator_ColumnVarNameInTable="columnf_captura" msprop:Generator_ColumnPropNameInRow="f_captura" msprop:Generator_ColumnPropNameInTable="f_capturaColumn" type="xs:dateTime" />
              <xs:element name="f_movto" msprop:Generator_UserColumnName="f_movto" msprop:Generator_ColumnVarNameInTable="columnf_movto" msprop:Generator_ColumnPropNameInRow="f_movto" msprop:Generator_ColumnPropNameInTable="f_movtoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="gan_cor" msprop:Generator_UserColumnName="gan_cor" msprop:Generator_ColumnVarNameInTable="columngan_cor" msprop:Generator_ColumnPropNameInRow="gan_cor" msprop:Generator_ColumnPropNameInTable="gan_corColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ubicacion" msprop:Generator_UserColumnName="ubicacion" msprop:Generator_ColumnVarNameInTable="columnubicacion" msprop:Generator_ColumnPropNameInRow="ubicacion" msprop:Generator_ColumnPropNameInTable="ubicacionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="empadre" msprop:Generator_UserColumnName="empadre" msprop:Generator_ColumnVarNameInTable="columnempadre" msprop:Generator_ColumnPropNameInRow="empadre" msprop:Generator_ColumnPropNameInTable="empadreColumn" type="xs:int" />
              <xs:element name="usuario" msprop:Generator_UserColumnName="usuario" msprop:Generator_ColumnVarNameInTable="columnusuario" msprop:Generator_ColumnPropNameInRow="usuario" msprop:Generator_ColumnPropNameInTable="usuarioColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="estatus" msprop:Generator_UserColumnName="estatus" msprop:Generator_ColumnVarNameInTable="columnestatus" msprop:Generator_ColumnPropNameInRow="estatus" msprop:Generator_ColumnPropNameInTable="estatusColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NomAni" msdata:ReadOnly="true" msprop:Generator_UserColumnName="NomAni" msprop:Generator_ColumnPropNameInRow="NomAni" msprop:Generator_ColumnVarNameInTable="columnNomAni" msprop:Generator_ColumnPropNameInTable="NomAniColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NomUbi" msdata:ReadOnly="true" msprop:Generator_UserColumnName="NomUbi" msprop:nullValue="_empty" msprop:Generator_ColumnVarNameInTable="columnNomUbi" msprop:Generator_ColumnPropNameInTable="NomUbiColumn" msprop:Generator_ColumnPropNameInRow="NomUbi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="movtos2" msprop:Generator_UserTableName="movtos2" msprop:Generator_RowDeletedName="movtos2RowDeleted" msprop:Generator_RowChangedName="movtos2RowChanged" msprop:Generator_RowClassName="movtos2Row" msprop:Generator_RowChangingName="movtos2RowChanging" msprop:Generator_RowEvArgName="movtos2RowChangeEvent" msprop:Generator_RowEvHandlerName="movtos2RowChangeEventHandler" msprop:Generator_TableClassName="movtos2DataTable" msprop:Generator_TableVarName="tablemovtos2" msprop:Generator_RowDeletingName="movtos2RowDeleting" msprop:Generator_TablePropName="movtos2">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="animal" msprop:Generator_UserColumnName="animal" msprop:Generator_ColumnVarNameInTable="columnanimal" msprop:Generator_ColumnPropNameInRow="animal" msprop:Generator_ColumnPropNameInTable="animalColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="animalid" msprop:Generator_UserColumnName="animalid" msprop:Generator_ColumnVarNameInTable="columnanimalid" msprop:Generator_ColumnPropNameInRow="animalid" msprop:Generator_ColumnPropNameInTable="animalidColumn" type="xs:int" />
              <xs:element name="veces" msdata:ReadOnly="true" msprop:Generator_UserColumnName="veces" msprop:Generator_ColumnVarNameInTable="columnveces" msprop:Generator_ColumnPropNameInRow="veces" msprop:Generator_ColumnPropNameInTable="vecesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Nombre" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Nombre" msprop:Generator_ColumnVarNameInTable="columnNombre" msprop:Generator_ColumnPropNameInRow="Nombre" msprop:Generator_ColumnPropNameInTable="NombreColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sx" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Sx" msprop:Generator_ColumnVarNameInTable="columnSx" msprop:Generator_ColumnPropNameInRow="Sx" msprop:Generator_ColumnPropNameInTable="SxColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:animal" />
      <xs:field xpath="mstns:AnimalId" />
    </xs:unique>
    <xs:unique name="categorias_catalogo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:categorias_catalogo" />
      <xs:field xpath="mstns:cattip" />
    </xs:unique>
    <xs:unique name="catalogo_general_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:catalogo_general" />
      <xs:field xpath="mstns:cattip" />
      <xs:field xpath="mstns:catcve" />
    </xs:unique>
    <xs:unique name="empadre_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:empadre" />
      <xs:field xpath="mstns:empadreId" />
    </xs:unique>
    <xs:keyref name="Rel_Empadres" refer="empadre_Constraint1" msdata:ConstraintOnly="true" msdata:AcceptRejectRule="Cascade" msdata:UpdateRule="None">
      <xs:selector xpath=".//mstns:Emp_Movs" />
      <xs:field xpath="mstns:empadreId" />
    </xs:keyref>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_CatalogoId" msdata:parent="categorias_catalogo" msdata:child="catalogo_general" msdata:parentkey="cattip" msdata:childkey="cattip" msprop:Generator_UserRelationName="FK_CatalogoId" msprop:Generator_RelationVarName="relationFK_CatalogoId" msprop:Generator_UserChildTable="catalogo_general" msprop:Generator_UserParentTable="categorias_catalogo" msprop:Generator_ParentPropName="categorias_catalogoRow" msprop:Generator_ChildPropName="Getcatalogo_generalRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>